<?php

require_once( '../system/smarty.inc' );
require_once( '../system/mdao/Class_M_COST_TVSP.php' );
require_once( '../system/mdao/Class_M_OTHER.php' );
require_once( '../system/Class_ERROR.php' );
require_once( '../system/login.inc.php' );
require_once( '../system/aoki_m.php' );
require_once( '../system/Class_PWD.php' );

Class_PWD::valid_auth(AOKI_AUTH_COST,$login['staff_auth']);

$dosearch = FALSE ;
$dao = new Class_M_COST_TVSP;
/*
if ( isset( $_GET['csv'] ) &&  (  $_GET['csv'] == "download" ) ||
	 isset( $_GET['hist'] ) &&  (  $_GET['hist'] == "2" ) ) {
	 $forms =  $_SESSION['MSEARCH']['COST_FLIER'];
}else {
	
	$_SESSION['MSEARCH']['COST_FLIER'] = $forms;
}
*/

$forms = $_GET;
$wherearr =  array();

if ( isset( $forms['year4'] ) &&  ( !empty( $forms['year4'] ) ) ){
	$year4 = $forms['year4'] ;
	$wherearr[] = "b.year4 =  '{$year4}' ";
}
$month_begin = 0;
$month_end   = 0;

if ( isset( $forms['months'] ) &&  ( !empty( $forms['months'] ) ) ){
	$month = $forms['months']<10 ? "0".$forms['months'] : $forms['months'];
	$month_begin = $forms['year4'].$month."01";
	$month_end   = $forms['year4'].$month."31";
}

/*
if ( isset( $forms['mater_id'] ) &&  ( !empty( $forms['mater_id'] ) ) ){
	$wherearr[] = sprintf("a.mater_id =  '%s' ",  $forms['mater_id'] );
}
*/

//---CSVダウンロード　処理開始
if ( isset( $_GET['csv'] ) &&  (  $_GET['csv'] == "download" ) ){
	$_GET["csv"] = "";
	$tmpfilename = "cost_tvsp".date("Ymd_His");
	header("Content-Type: application/octet-stream"); 
	header("Content-Disposition: attachment; filename=$tmpfilename.csv");
	
	if ($login['staff_auth'] == "G-9" ) {
		$electrics = Class_M_OTHER::get_electric_array(NULL, $login['autoid'] );
		$arrelc= array_keys($electrics);
		$data = $dao->searchcostcsv( $month_begin, $month_end, $arrelc[0] );
	}else {
		$data = $dao->searchcostcsv( $month_begin, $month_end );
	}
	$colums = array();

	$col_heads = array(
		'year4'            => array( '年度',        1),
		'month'            => array( '月度',        1),
		'week_cd'             => array( '週名',        1),
		'tele_date_start'  => array( '放映開始日',  1),
		'tele_date_end'    => array( '放映終了日',  1),
		'electric_name'    => array( '電波圏名',    1),
		'mater_name'       => array( '素材名',      1),
		'grp'              => array( 'GRP',         2),
		'cosrt'            => array( '金額',        2),
		'now_grp'          => array( '本年(GRP)',   2),
		'pre_grp'       	=> array( '前年(GRP)',   2),
		'rate_grp'         => array( '前比(GRP)',   2),
		'diff_grp'         => array( '差異(GRP)',   2),
		'now_cost'        => array( '本年(金額)',  2),
		'pre_cost'     	=> array( '前年(金額)',  2),
		'rate_cost'       => array( '前比(金額)',  2),
		'diff_cost'       => array( '差異(金額)',  2)
	);

	//列名
	foreach ($col_heads as $k=>$v) {
		$colums["name"][]   = $k;
		$colums["head"][]   = $v[0];
		$colums["type"][$k] = $v[1];
	}
	//データ整形開始
	foreach ($data as $k => $v) {
		$data[$k]["year4"] = $year4;
		$data[$k]["month"] = $month;
		$data[$k]["week_cd"]  = $v["week_cd"]."週";
		
		$data[$k]["tele_date_start"]  =  Class_PWD::int8_to_date($v["flier_date"]);
		$data[$k]["tele_date_end"]    =  Class_PWD::int8_to_date($v["tele_date_end"]);
		
		//前年比   前年差異
		$data[$k]["diff_grp"] =  $v["now_grp"] - $v["pre_grp"];
		if ( !empty($v["pre_grp"]) ) {
			$data[$k]["rate_grp"] =  $v["now_grp"] / $v["pre_grp"] * 100;
		}else {
			
		}
		
		$data[$k]["diff_cost"] =  $v["now_cost"] - $v["pre_cost"];
		if ( !empty($v["pre_cost"]) ) {
			$data[$k]["rate_cost"] =  $v["now_cost"] / $v["pre_cost"] * 100;
		}else {
			
		}
		
		
	}
	//データ整形完了
	$dao->output_csv($data, $colums);
	exit;
}



/*
if ( isset( $forms['search'] ) && (  !empty( $forms['search'] ) ) ){
	$dosearch = TRUE;
}

if( isset( $forms['page'] ) && is_numeric( $forms['page'] ) ){
	$dosearch = TRUE;
	$page['current'] = $forms['page'];
}else{
	$page['current'] = 1;
}

$page['item'] = PAGE_MAX;

if ($dosearch) {
	//$page内容は関数内部更新されます。
	$data = $dao->search( $wherearr, $page );

	//表示ために整形開始
	foreach ($data as $k => $v ) {
		$data[$k]["sent_date"] = Class_PWD::int8_to_date($v["sent_date"]) ;
	}
}
//表示ために整形完了
*/

$months = array();
$months[""] = PLEASE_SELECT_ARR;
for( $a = 1; $a <= 12; $a++ )
{
	$months[$a] = "&nbsp;".$a;
}
$smarty->assign('months', $months );

if (empty($forms["year4"])) {
	$forms["year4"] = date('Y');
}
$smarty->assign('year4',  Class_PWD::get_years());
$week= Class_M_OTHER::get_week_array( $forms["year4"], PLEASE_SELECT_ARR );
$smarty->assign('week', $week );
/*
$electrics = Class_M_OTHER::get_electric_array(PLEASE_SELECT_ARR);
$smarty->assign('electrics', $electrics );

$maters =  Class_M_OTHER::get_mater_array($forms["electric_id"], PLEASE_SELECT_ARR ) ;
$smarty->assign('maters', $maters );
*/
if( isset($forms) ) $smarty->assign('forms', $forms);
if( isset($data) )  $smarty->assign('data', $data);
//if( isset($disp) )  $smarty->assign('disp', $disp);
if( isset($page) )  $smarty->assign('page', $page);

$smarty->assign('menu', $smarty->fetch('menu.html') );
$smarty->assign('logout', $smarty->fetch('logout.html') );
$smarty->assign('footer', $smarty->fetch('footer.html') );
$smarty->assign('pageing', $smarty->fetch('page.html') );
$smarty->display('mcost_tvsp_export.html');
?>